package io.renren.utils;

import io.renren.config.MongoManager;
import io.renren.entity.ColumnEntity;
import io.renren.entity.TableEntity;
import io.renren.entity.mongo.MongoDefinition;
import io.renren.entity.mongo.MongoGeneratorEntity;
import org.apache.commons.configuration.Configuration;
import org.apache.commons.configuration.ConfigurationException;
import org.apache.commons.configuration.PropertiesConfiguration;
import org.apache.commons.io.IOUtils;
import org.apache.commons.lang.StringUtils;
import org.apache.velocity.Template;
import org.apache.velocity.VelocityContext;
import org.apache.velocity.app.Velocity;

import java.io.File;
import java.io.IOException;
import java.io.StringWriter;
import java.util.*;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

/**
 * 代码生成器   工具类
 *
 * @author chenshun
 * @email sunlightcs@gmail.com
 * @date 2016年12月19日 下午11:40:24
 */
public class GenUtils {

    private static String currentTableName;

    public static List<String> getTemplates(int type) {
        List<String> templates = new ArrayList<String>();
//        templates.add("template/Entity.java.vm");
//        templates.add("template/Dao.xml.vm");
//
//        templates.add("template/menu.sql.vm");
//
//        templates.add("template/Service.java.vm");
//        templates.add("template/ServiceImpl.java.vm");
//        templates.add("template/Controller.java.vm");
//        templates.add("template/Dao.java.vm");
//        templates.add("template/index.vue.vm");
//        templates.add("template/add-or-update.vue.vm");
        if (type == 0) {

            templates.add("template/c#/AutoMapper.txt.vm");
            templates.add("template/c#/Controller.cs.vm");
            templates.add("template/c#/DTO.cs.vm");
            templates.add("template/c#/Entity.cs.vm");
            templates.add("template/c#/IRepository.cs.vm");
            templates.add("template/c#/IService.cs.vm");
            templates.add("template/c#/Repository.cs.vm");
            templates.add("template/c#/Service.cs.vm");
//        templates.add("template/c#/TypeId.cs.vm");
//        templates.add("template/c#/TypeName.cs.vm");
            templates.add("template/c#/VO.cs.vm");
//        templates.add("template/c#/Dto_Info.cs.vm");
//        templates.add("template/c#/Dto_Table.cs.vm");

        }
        if (type == 1) {
            templates.add("template/masa/AddCommand.cs.vm");
            templates.add("template/masa/AddOrUpdateVo.cs.vm");
            templates.add("template/masa/CommandHandler.cs.vm");
            templates.add("template/masa/Controller.cs.vm");
            templates.add("template/masa/DeleteCommand.cs.vm");
            templates.add("template/masa/DTO.cs.vm");
            templates.add("template/masa/GetListQueries.cs.vm");
            templates.add("template/masa/GetQueries.cs.vm");
            templates.add("template/masa/IRepository.cs.vm");
            templates.add("template/masa/IService.cs.vm");
            templates.add("template/masa/QueryHandler.cs.vm");
            templates.add("template/masa/Repository.cs.vm");
            templates.add("template/masa/UpdateCommand.cs.vm");
        }
        if (MongoManager.isMongo()) {
            // mongo不需要mapper、sql   实体类需要替换
            templates.remove(0);
            templates.remove(1);
            templates.remove(2);
            templates.add("template/MongoEntity.java.vm");
        }
        return templates;
    }

    public static List<String> getMongoChildTemplates() {
        List<String> templates = new ArrayList<String>();
        templates.add("template/MongoChildrenEntity.java.vm");
        return templates;
    }

    /**
     * 生成代码
     */
    public static void generatorCode(Map<String, String> table,
                                     String subPath,
                                     List<Map<String, String>> columns, ZipOutputStream zip) {
        //配置信息
        Configuration config = getConfig();
        boolean hasBigDecimal = false;
        boolean hasList = false;
        //表信息
        TableEntity tableEntity = new TableEntity();
        tableEntity.setTableName(table.get("tableName"));
        tableEntity.setComments(table.get("tableComment"));
        //表名转换成Java类名
        String className = tableToJava(tableEntity.getTableName(), config.getStringArray("tablePrefix"));
        className = className.replaceAll("_", "");
        tableEntity.setClassName(className);
        tableEntity.setClassname(StringUtils.uncapitalize(className));
        tableEntity.setModelName(config.getStringArray("tablePrefix") + className);
        for (Map<String, String> column : columns) {
            ColumnEntity columnEntity = new ColumnEntity();
            columnEntity.setColumnName(column.get("columnName"));
            columnEntity.setDataType(column.get("dataType"));
            columnEntity.setComments(column.get("columnComment"));
            columnEntity.setExtra(column.get("extra"));

            //列名转换成Java属性名
            String attrName = columnToJava(columnEntity.getColumnName());
            attrName = attrName.replaceAll("ID", "Id");
            columnEntity.setAttrName(attrName);
            columnEntity.setAttrname(StringUtils.uncapitalize(attrName));

            //列的数据类型，转换成Java类型
            String attrType = config.getString(columnEntity.getDataType(), columnToJava(columnEntity.getDataType()));
            if (attrType.equals("datetime2")) {
                attrType = "DateTime";
            }
            columnEntity.setAttrType(attrType);

            if (attrName.contains("Name") || attrName.contains("Code")) {
                columnEntity.setDomainType(attrName.replaceAll("Code", "Name"));
            }

            if (!hasBigDecimal && attrType.equals("BigDecimal")) {
                hasBigDecimal = true;
            }
            if (!hasList && "array".equals(columnEntity.getExtra())) {
                hasList = true;
            }
            boolean isKey = false;
            //是否主键
            if ("PRI".equalsIgnoreCase(column.get("columnKey")) && tableEntity.getPk() == null) {
                tableEntity.setPk(columnEntity);
                isKey = true;
            }
            //是否外键
            if (column.get("foreignKey").equalsIgnoreCase("FRI")) {
                String fkName = attrName.replaceFirst("ID", "");
                columnEntity.setFkName(fkName);
                tableEntity.getFks().add(columnEntity);
                isKey = true;
            }
            if (!isKey) {
                tableEntity.getColumns().add(columnEntity);
            }
            if (attrType.equals("DateTime") || columnEntity.getColumnName().equals("Sequence")) {

                tableEntity.getColumsSort().add(columnEntity);
            }
        }


        //没主键，则第一个字段为主键
        if (tableEntity.getPk() == null) {
            tableEntity.setPk(tableEntity.getColumns().get(0));
        }

        //设置velocity资源加载器
        Properties prop = new Properties();
        prop.put("file.resource.loader.class", "org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader");
        Velocity.init(prop);
        String mainPath = config.getString("mainPath");
        String startName = config.getString("startName");
        mainPath = StringUtils.isBlank(mainPath) ? "io.renren" : mainPath;
        //封装模板数据
        Map<String, Object> map = new HashMap<>();
        map.put("tableName", tableEntity.getTableName());
        map.put("comments", tableEntity.getComments());
        map.put("pk", tableEntity.getPk());
        map.put("fks", tableEntity.getFks());
        map.put("className", tableEntity.getClassName());
//        map.put("classname", tableEntity.getClassname());
        map.put("modelName", tableEntity.getModelName());
        map.put("pathName", tableEntity.getClassname().toLowerCase());
        map.put("columns", tableEntity.getColumns());
        map.put("columnSort", tableEntity.getColumsSort());
        map.put("hasBigDecimal", hasBigDecimal);
        map.put("hasList", hasList);
        map.put("mainPath", mainPath);
        map.put("startName", startName);
        map.put("subPath", subPath);
        map.put("package", config.getString("package"));
        map.put("moduleName", config.getString("moduleName"));
        map.put("author", config.getString("author"));
        map.put("email", config.getString("email"));
        map.put("datetime", DateUtils.format(new Date(), DateUtils.DATE_TIME_PATTERN));
        VelocityContext context = new VelocityContext(map);
        int num = config.getInt("type");
        //获取模板列表
        List<String> templates = getTemplates(num);
        for (String template : templates) {
            //渲染模板
            StringWriter sw = new StringWriter();
            Template tpl = Velocity.getTemplate(template, "UTF-8");
            tpl.merge(context, sw);

            try {
                //添加到zip
                zip.putNextEntry(new ZipEntry(getFileName(template, tableEntity.getClassName(), num)));
                IOUtils.write(sw.toString(), zip, "UTF-8");
                IOUtils.closeQuietly(sw);
                zip.closeEntry();
            } catch (IOException e) {
                throw new RRException("渲染模板失败，表名：" + tableEntity.getTableName(), e);
            }
        }
    }

    /**
     * 生成mongo其他实体类的代码
     */
    public static void generatorMongoCode(String[] tableNames, ZipOutputStream zip) {
        for (String tableName : tableNames) {
            MongoDefinition info = MongoManager.getInfo(tableName);
            currentTableName = tableName;
            List<MongoGeneratorEntity> childrenInfo = info.getChildrenInfo(tableName);
            childrenInfo.remove(0);
            for (MongoGeneratorEntity mongoGeneratorEntity : childrenInfo) {
                generatorChildrenBeanCode(mongoGeneratorEntity, zip);
            }
        }
    }

    private static void generatorChildrenBeanCode(MongoGeneratorEntity mongoGeneratorEntity, ZipOutputStream zip) {
        //配置信息
        Configuration config = getConfig();
        boolean hasList = false;
        //表信息
        TableEntity tableEntity = mongoGeneratorEntity.toTableEntity();
        //表名转换成Java类名
        String className = tableToJava(tableEntity.getTableName(), config.getStringArray("tablePrefix"));
        tableEntity.setClassName(className);
        tableEntity.setClassname(StringUtils.uncapitalize(className));
        //列信息
        List<ColumnEntity> columsList = new ArrayList<>();
        for (Map<String, String> column : mongoGeneratorEntity.getColumns()) {
            ColumnEntity columnEntity = new ColumnEntity();
            String columnName = column.get("columnName");
            if (columnName.contains(".")) {
                columnName = columnName.substring(columnName.lastIndexOf(".") + 1);
            }
            columnEntity.setColumnName(columnName);
            columnEntity.setDataType(column.get("dataType"));
            columnEntity.setExtra(column.get("extra"));

            //列名转换成Java属性名
            String attrName = columnToJava(columnEntity.getColumnName());
            columnEntity.setAttrName(attrName);
            columnEntity.setAttrname(StringUtils.uncapitalize(attrName));

            //列的数据类型，转换成Java类型
            String attrType = config.getString(columnEntity.getDataType(), columnToJava(columnEntity.getDataType()));
            if (attrType.equals("datetime2")) {
                attrType = "DateTime";
            }
            columnEntity.setAttrType(attrType);

            if (!hasList && "array".equals(columnEntity.getExtra())) {
                hasList = true;
            }
            columsList.add(columnEntity);
        }
        tableEntity.setColumns(columsList);

        //设置velocity资源加载器
        Properties prop = new Properties();
        prop.put("file.resource.loader.class", "org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader");
        Velocity.init(prop);
        String mainPath = config.getString("mainPath");
        mainPath = StringUtils.isBlank(mainPath) ? "io.renren" : mainPath;
        //封装模板数据
        Map<String, Object> map = new HashMap<>();
        map.put("tableName", tableEntity.getTableName());
        map.put("comments", tableEntity.getComments());
        map.put("pk", tableEntity.getPk());
        map.put("className", tableEntity.getClassName());
        map.put("classname", tableEntity.getClassname());
        map.put("pathName", tableEntity.getClassname().toLowerCase());
        map.put("columns", tableEntity.getColumns());
        map.put("hasList", hasList);
        map.put("mainPath", config.getString("mainPath"));
        map.put("package", config.getString("package"));
        map.put("moduleName", config.getString("moduleName"));
        map.put("author", config.getString("author"));
        map.put("email", config.getString("email"));
        map.put("datetime", DateUtils.format(new Date(), DateUtils.DATE_TIME_PATTERN));
        VelocityContext context = new VelocityContext(map);

        //获取模板列表
        List<String> templates = getMongoChildTemplates();
        for (String template : templates) {
            //渲染模板
            StringWriter sw = new StringWriter();
            Template tpl = Velocity.getTemplate(template, "UTF-8");
            tpl.merge(context, sw);
            try {
                //添加到zip
                zip.putNextEntry(new ZipEntry(getFileName(template, tableEntity.getClassName(), config.getString("package"), config.getString("moduleName"))));
                IOUtils.write(sw.toString(), zip, "UTF-8");
                IOUtils.closeQuietly(sw);
                zip.closeEntry();
            } catch (IOException e) {
                throw new RRException("渲染模板失败，表名：" + tableEntity.getTableName(), e);
            }
        }

    }

    /**
     * 列名转换成Java属性名
     */
    public static String columnToJava(String columnName) {
//        return WordUtils.capitalizeFully(columnName, new char[]{'_'}).replace("_", "");
        return columnName;
    }

    /**
     * 表名转换成Java类名
     */
    public static String tableToJava(String tableName, String[] tablePrefixArray) {
        if (null != tablePrefixArray) {
            for (String tablePrefix : tablePrefixArray) {
                //   if (tableName.startsWith(tablePrefix)){
                tableName = tableName.replaceFirst(tablePrefix, "");
                //}
            }
        }
        return columnToJava(tableName);
    }

    /**
     * 获取配置信息
     */
    public static Configuration getConfig() {
        try {
            return new PropertiesConfiguration("generator-c#.properties");
        } catch (ConfigurationException e) {
            throw new RRException("获取配置文件失败，", e);
        }
    }


    public static String getFileName(String template, String className, int num) {
        if (num == 0) {

            if (template.contains("AutoMapper.txt.vm")) {
                return "AutoMapper" + "/" + className + "AutoMapper.txt";
            }
            if (template.contains("Controller.cs.vm")) {
                return "Controller" + "/" + className + "Controller.cs";
            }
            if (template.contains("DTO.cs.vm")) {
                return "Dto" + "/" + className + "Dto.cs";
            }
            if (template.contains("Entity.cs.vm")) {
                return "Entity" + "/" + className + ".cs";
            }
            if (template.contains("IRepository.cs.vm")) {
                return "IRepository" + "/" + "I" + className + "Repository.cs";
            }
            if (template.contains("IService.cs.vm")) {
                return "IService" + "/" + "I" + className + "Service.cs";
            }
            if (template.contains("Repository.cs.vm")) {
                return "Repository" + "/" + className + "Repository.cs";
            }
            if (template.contains("Service.cs.vm")) {
                return "Service" + "/" + className + "Service.cs";
            }
            if (template.contains("TypeId.cs.vm")) {
                return "TypeId" + "/" + className + "Id.cs";
            }
            if (template.contains("TypeName.cs.vm")) {
                return "TypeName" + "/" + className + "Name.cs";
            }
            if (template.contains("VO.cs.vm")) {
                return "VO" + "/" + className + "Vo.cs";
            }
            if (template.contains("Dto_Info.cs.vm")) {
                return "Dto" + "/" + className + "Dto_Info.cs";
            }
            if (template.contains("Dto_Table.cs.vm")) {
                return "Dto" + "/" + className + "Dto_Table.cs";
            }
        }

        if (num == 1) {
            if (template.contains("AddCommand.cs.vm")) {
                return "Handler/" + className + "Services/Commands" + "/Create" + className + "Command.cs";
            }
            if (template.contains("AddOrUpdateVo.cs.vm")) {
                return "IServiceEntity/" + className + "/Aggregates/" + className + "CreateUpdateVo.cs";
            }
            if (template.contains("CommandHandler.cs.vm")) {
                return "Handler/" + className + "Services" + "/" + className + "CommandHandler.cs";
            }
            if (template.contains("Controller.cs.vm")) {
                return "Controller" + "/" + className + "Service.cs";
            }
            if (template.contains("DeleteCommand.cs.vm")) {
                return "Handler/" + className + "Services/Commands" + "/Delete" + className + "Command.cs";
            }
            if (template.contains("DTO.cs.vm")) {
                return "IServiceEntity/" + className + "/Aggregates/" + className + "Dto.cs";
            }
            if (template.contains("GetListQueries.cs.vm")) {
                return "Handler/" + className + "Services/Queries" + "/Get" + className + "ListQuery.cs";
            }
            if (template.contains("GetQueries.cs.vm")) {
                return "Handler/" + className + "Services/Queries" + "/Get" + className + "Query.cs";
            }
            if (template.contains("IRepository.cs.vm")) {
                return "Domain/" + "/I" + className + "Repository.cs";
            }
            if (template.contains("IService.cs.vm")) {
                return "IServiceEntity/" + className + "/Services/I" + className + "Service.cs";
            }
            if (template.contains("QueryHandler.cs.vm")) {
                return "Handler/" + className + "Services" + "/" + className + "QueryHandler.cs";
            }
            if (template.contains("Repository.cs.vm")) {
                return "Repository/" + className + "Repository.cs";
            }
            if (template.contains("UpdateCommand.cs.vm")) {
                return "Handler/" + className + "Services/Commands" + "/Update" + className + "Command.cs";
            }
        }

        return null;
    }

    /**
     * 获取文件名
     */
    public static String getFileName(String template, String className, String packageName, String moduleName) {
        String packagePath = "main" + File.separator + "java" + File.separator;
        if (StringUtils.isNotBlank(packageName)) {
            packagePath += packageName.replace(".", File.separator) + File.separator + moduleName + File.separator;
        }
        if (template.contains("MongoChildrenEntity.java.vm")) {
            return packagePath + "entity" + File.separator + "inner" + File.separator + currentTableName + File.separator + splitInnerName(className) + "InnerEntity.java";
        }
        if (template.contains("Entity.java.vm") || template.contains("MongoEntity.java.vm")) {
            return packagePath + "entity" + File.separator + className + "Entity.java";
        }

        if (template.contains("Dao.java.vm")) {
            return packagePath + "dao" + File.separator + className + "Dao.java";
        }

        if (template.contains("Service.java.vm")) {
            return packagePath + "service" + File.separator + className + "Service.java";
        }

        if (template.contains("ServiceImpl.java.vm")) {
            return packagePath + "service" + File.separator + "impl" + File.separator + className + "ServiceImpl.java";
        }

        if (template.contains("Controller.java.vm")) {
            return packagePath + "controller" + File.separator + className + "Controller.java";
        }

        if (template.contains("Dao.xml.vm")) {
            return "main" + File.separator + "resources" + File.separator + "mapper" + File.separator + moduleName + File.separator + className + "Dao.xml";
        }

        if (template.contains("menu.sql.vm")) {
            return className.toLowerCase() + "_menu.sql";
        }

        if (template.contains("index.vue.vm")) {
            return "main" + File.separator + "resources" + File.separator + "src" + File.separator + "views" + File.separator + "modules" +
                    File.separator + moduleName + File.separator + className.toLowerCase() + ".vue";
        }

        if (template.contains("add-or-update.vue.vm")) {
            return "main" + File.separator + "resources" + File.separator + "src" + File.separator + "views" + File.separator + "modules" +
                    File.separator + moduleName + File.separator + className.toLowerCase() + "-add-or-update.vue";
        }

        return null;
    }

    private static String splitInnerName(String name) {
        name = name.replaceAll("\\.", "_");
        return name;
    }
}
